Running the Audit_01 Income Statement Summary report

The Income Statement Summary report provides a point of validation to ensure proper import of the General Ledger file into the Axiom system from the source system. You need to generate a similar report from the source system to validate against this standard Costing Income Statement Summary. The report populates based on your defined fiscal period configured at implementation as well as the costing period you define in the Key Dates driver file.

To run the Audit_01 Income Statement Summary report:

1. In the Explorer task pane, in the Libraries section, click Costing Reports > Data Import Validations, and double-click Audit_01 Income Statement Summary.

   

2. Refresh the variables by doing one of the following:

   • In the Main tab, in the Workbook Options section, click Refresh Data.

     

   • Press F9.
3. In the Refresh Variables dialog, select the variables to include in the report, and click OK.

When compared to the generated source system report:

• This report should equal or tie out completely in total and ideally by line items.
• Line item variances are likely due to classification at the FSDetail level in the ACCT dimension table and the definition of the financial statements and/or reports used as the comparison.
• Variances in total are likely due to filters applied on either side of the reporting, e.g., defined Entities.

NOTE: You need to update any new accounts or departments added during an import in the ACCT and DEPT dimension tables for the reconciliation report to tie out completely.